Tabela Reservation

Definicja tabeli Reservation

Name

Reservation

Code

Reservation

Comment

PL: Dane rezerwacji przedzialu czasowego dla pacjenta.
EN: Reservation's data
DE: Tabelle fur das Reservat der Einlasszeit fur Patienten


Lista kolumn tabeli Reservation

Name

Code

ReservationID

ReservationID

Res_ReservationID

Res_ReservationID

TimePatternID

TimePatternID

ServID

ServID

VisitTypeID

VisitTypeID

TimePatternTimeSlotID

TimePatternTimeSlotID

MedResourceID

MedResourceID

PersonID

PersonID

ReservationStatusID

ReservationStatusID

ReferralID

ReferralID

ReservationTypeID

ReservationTypeID

RehabilitationID

RehabilitationID

StartDT

StartDT

StopDT

StopDT

Comments

Comments

BenefitPlanContractID

BenefitPlanContractID

Active

Active

isConfirmed

isConfirmed

RehabilitationGroupID

RehabilitationGroupID


Kolumna ReservationID tabeli Reservation

Definicja kolumny ReservationID tabeli Reservation

Name

ReservationID

Code

ReservationID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID rezerwacji


Kolumna Res_ReservationID tabeli Reservation

Definicja kolumny Res_ReservationID tabeli Reservation

Name

Res_ReservationID

Code

Res_ReservationID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna TimePatternID tabeli Reservation

Definicja kolumny TimePatternID tabeli Reservation

Name

TimePatternID

Code

TimePatternID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ServID tabeli Reservation

Definicja kolumny ServID tabeli Reservation

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna VisitTypeID tabeli Reservation

Definicja kolumny VisitTypeID tabeli Reservation

Name

VisitTypeID

Code

VisitTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

W przypadku planowania hospitalizacji = null.


Kolumna TimePatternTimeSlotID tabeli Reservation

Definicja kolumny TimePatternTimeSlotID tabeli Reservation

Name

TimePatternTimeSlotID

Code

TimePatternTimeSlotID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna MedResourceID tabeli Reservation

Definicja kolumny MedResourceID tabeli Reservation

Name

MedResourceID

Code

MedResourceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonID tabeli Reservation

Definicja kolumny PersonID tabeli Reservation

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ReservationStatusID tabeli Reservation

Definicja kolumny ReservationStatusID tabeli Reservation

Name

ReservationStatusID

Code

ReservationStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ReferralID tabeli Reservation

Definicja kolumny ReferralID tabeli Reservation

Name

ReferralID

Code

ReferralID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID Skierowania


Kolumna ReservationTypeID tabeli Reservation

Definicja kolumny ReservationTypeID tabeli Reservation

Name

ReservationTypeID

Code

ReservationTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID typu rezerwacji


Kolumna RehabilitationID tabeli Reservation

Definicja kolumny RehabilitationID tabeli Reservation

Name

RehabilitationID

Code

RehabilitationID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID cyklu rehabilitacyjnego


Kolumna StartDT tabeli Reservation

Definicja kolumny StartDT tabeli Reservation

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli Reservation

Definicja kolumny StopDT tabeli Reservation

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Comments tabeli Reservation

Definicja kolumny Comments tabeli Reservation

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna BenefitPlanContractID tabeli Reservation

Definicja kolumny BenefitPlanContractID tabeli Reservation

Name

BenefitPlanContractID

Code

BenefitPlanContractID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Active tabeli Reservation

Definicja kolumny Active tabeli Reservation

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna isConfirmed tabeli Reservation

Definicja kolumny isConfirmed tabeli Reservation

Name

isConfirmed

Code

isConfirmed

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Czy rezerwacja jest potwierdzona


Kolumna RehabilitationGroupID tabeli Reservation

Definicja kolumny RehabilitationGroupID tabeli Reservation

Name

RehabilitationGroupID

Code

RehabilitationGroupID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli Reservation

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Reservation

Definicja klucza Identifier_1 tabeli Reservation

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment